Once you modify the join type of your query when using the Insert Rows transformation, you are unable to make additional changes to this join type. The default join type for a query generated by the Insert Rows transformation is an inner join. When you modify the inner join to another join type, such as left join, right join, or full join, you cannot make another modification to the type of join.

To work around this issue, delete the row containing the incorrect join type and then add the row again. You are then able to change the type of join on the newly added row.

Operating System and Release Information